﻿using System;
using System.Collections.Generic;
using System.Text;

namespace LTJ.Data
{
    public class DbFields
    {
        /// <summary>
        /// 用户信息字段
        /// </summary>
        public const string USERINFO = "[id],[lname],[rname],[ename],[email],[pass],[gid],[cid],[createdate],[lastdate],[ip],[status],[authority],[scores],[source],[creater],[syspass],[gender],[phone],[bio],[olcode]";
        /// <summary>
        /// 用户组信息字段
        /// </summary>
        public const string USERGROUPINFO = "[id],[name],[sort],[auths],[status],[backup]";
        /// <summary>
        /// 企业信息字段
        /// </summary>
        public const string COMPANY = "[id],[cname],[ecname],[logo],[welcome],[relater],[relateform],[bio],[status],[manager],[phone],[scores],[main],[createdate],[creater],[email],[weburl],[msn],[mcount],[ucount]";
        /// <summary>
        /// 基本类型信息字段
        /// </summary>
        public const string BASETYPE = "[code],[tname],[etname],[expand]";
        /// <summary>
        /// 基本数据信息字段
        /// </summary>
        public const string BASEDATA = "[id],[code],[tcode],[name],[ename],[expand1],[expand2],[expand3]";
        /// <summary>
        /// 航线授权信息字段
        /// </summary>
        public const string ROUTE = "[id],[cid],[tcode],[tname],[bcode],[bname],[creater],[createdate]";
        /// <summary>
        /// 航线基本信息字段
        /// </summary>
        public const string ROUTEBASE = "[id],[loadport],[destport],[tranport],[bcode],[pier],[schbegin],[schend],[range],[validbegin],[validend],[bio],[cid],[uid],[createdate],[backup],[isuse]";
        /// <summary>
        /// 航线费用信息字段
        /// </summary>
        public const string ROUTEFEE = "[tcode],[dcode],[pcode],[vipprice],[regprice],[openprice],[rid]";
        /// <summary>
        /// 航线费用信息字段
        /// </summary>
        public const string ROUTEFEE2 = "[RF].[tcode],[RF].[dcode],[RF].[pcode],[RF].[vipprice],[RF].[regprice],[RF].[openprice],[RF].[rid]";

    }
}
